20. 练习：ORDER BY（第二部分）

问题

  1. 查询 orders 表格，按照订单日期的从新到旧降序排列，同时每个日期下的订单按照 total_amt_usd 降序排列，显示前5行。

  2. 查询 orders 表格，按照订单日期的从旧到新升序排列，同时每个日期下的订单按照 total_amt_usd 升序排列，显示前10行。

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity , so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: sql-evaluator
  • Opened files (when workspace is loaded): n/a

Next Concept